[dbo].[AtomPanelWebsite]

Property	Value
Created	10:31:14 AM Tuesday, March 02, 2010
Last Modified	11:40:00 AM Monday, February 20, 2012

Property

Value

Created

10:31:14 AM Tuesday, March 02, 2010

Last Modified

11:40:00 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_AtomPanelWebsite: AtomPanelKey\WebsiteKey$	AtomPanelKey	uniqueidentifier	16
$Cluster Primary Key PK_AtomPanelWebsite: AtomPanelKey\WebsiteKey$	WebsiteKey	uniqueidentifier	16
	WebUserControlPath	nvarchar(255)	510
	LastCompiledOn	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_AtomPanelWebsite: AtomPanelKey\WebsiteKey$

AtomPanelKey

uniqueidentifier

$Cluster Primary Key PK_AtomPanelWebsite: AtomPanelKey\WebsiteKey$

WebsiteKey

uniqueidentifier

WebUserControlPath

nvarchar(255)

510

LastCompiledOn

datetime

	Name	Columns	Unique
$Cluster Primary Key PK_AtomPanelWebsite: AtomPanelKey\WebsiteKey$	PK_AtomPanelWebsite	AtomPanelKey, WebsiteKey

Name

Columns

Unique

$Cluster Primary Key PK_AtomPanelWebsite: AtomPanelKey\WebsiteKey$

PK_AtomPanelWebsite

AtomPanelKey, WebsiteKey

Name	Columns
FK_AtomPanelWebsite_AtomPanel	AtomPanelKey->[dbo].[AtomPanel].[AtomPanelKey]
FK_AtomPanelWebsite_Website	WebsiteKey->[dbo].[Website].[WebsiteKey]

Name

Columns

FK_AtomPanelWebsite_AtomPanel

AtomPanelKey->[dbo].[AtomPanel].[AtomPanelKey]

FK_AtomPanelWebsite_Website

WebsiteKey->[dbo].[Website].[WebsiteKey]

SQL Script

CREATE TABLE [dbo].[AtomPanelWebsite]
(
[AtomPanelKey] [uniqueidentifier] NOT NULL,
[WebsiteKey] [uniqueidentifier] NOT NULL,
[WebUserControlPath] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastCompiledOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AtomPanelWebsite] ADD CONSTRAINT [PK_AtomPanelWebsite] PRIMARY KEY CLUSTERED ([AtomPanelKey], [WebsiteKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AtomPanelWebsite] ADD CONSTRAINT [FK_AtomPanelWebsite_AtomPanel] FOREIGN KEY ([AtomPanelKey]) REFERENCES [dbo].[AtomPanel] ([AtomPanelKey])
GO
ALTER TABLE [dbo].[AtomPanelWebsite] ADD CONSTRAINT [FK_AtomPanelWebsite_Website] FOREIGN KEY ([WebsiteKey]) REFERENCES [dbo].[Website] ([WebsiteKey])
GO